MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Alpha Sort = 18256

View and edit SQL

Suggested facets: Department, Object Name, Artist Display Bio, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
208519 1971.513.36 0 1 335882 Drawings and Prints 11 Drawing 23 Four Putti Decorating a Herm with Garlands of Fruit and Foliage           Artist 2   Jacob de Wit Dutch, Amsterdam 1695–1754 Amsterdam   Wit, Jacob de 18256 Dutch 11 1695 1754 early 18th century 1710 1754 Red chalk. Inlaid into heavy paper mount with brown and gold framing lines. 30157 16 1/8 x 6 3/4 in. (40.9 x 17.2 cm) (silhouetted into arch at top) Purchase, Harris Brisbane Dick Fund and Joseph Pulitzer Bequest, 1971                       Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
220819 64.197.10 0 1 348357 Drawings and Prints 11 Drawing 23 Apollo and Thetis           Artist 2   Jacob de Wit Dutch, Amsterdam 1695–1754 Amsterdam   Wit, Jacob de 18256 Dutch 11 1695 1754 early 18th century 1710 1754 Red, brown and gray wash over red chalk 34786 sheet: 9 5/8 x 12 11/16 in. (24.5 x 32.2 cm) Rogers Fund, 1964                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
220821 69.296 0 1 348359 Drawings and Prints 11 Drawing 23 Ceiling Design           Artist 2   Jacob de Wit Dutch, Amsterdam 1695–1754 Amsterdam   Wit, Jacob de 18256 Dutch 11 1695 1754 early 18th century 1710 1754 Pen and brown ink, brush and brown wash, over traces of red chalk. Quadruple framing line in pen and black ink. 34787 sheet: 11 7/8 x 8 1/2 in. (30.2 x 21.6 cm) Gift of Mrs. Richard Krautheimer, 1969                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
220822 61.130.14 0 1 348360 Drawings and Prints 11 Drawing 23 Allegorical Figures of Faith, Hope and Charity in a Niche           Artist 2   Jacob de Wit Dutch, Amsterdam 1695–1754 Amsterdam   Wit, Jacob de 18256 Dutch 11 1695 1754 early 18th century 1710 1754 Pen and black ink, brush and gray wash heightened with white on blue paper. Quadruple framing line in pen and black ink with red wash. 34788 sheet: 10 9/16 x 6 1/16 in. (26.9 x 15.4 cm) Rogers Fund, 1961                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
224412 2002.82 0 1 352005 Drawings and Prints 11 Drawing 23 Study for the figure of Moses           Artist 2   Jacob de Wit Dutch, Amsterdam 1695–1754 Amsterdam   Wit, Jacob de 18256 Dutch 11 1695 1754 1730–37 1730 1737 Point of the brush and black ink with black and gray wash over red chalk 35392 7 11/16 x 5 15/16 in. (19.6 x 15.1 cm) Purchase, Charles and Jessie Price Gift, 2002                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
307748 07.225.298 0 1 437946 European Paintings 15 Painting, sketch for a ceiling decoration 14088 Allegory of the Arts           Artist 2   Jacob de Wit Dutch, Amsterdam 1695–1754 Amsterdam   Wit, Jacob de 18256 Dutch 11 1695 1754 1742 1742 1742 Oil on canvas 953 18 7/8 x 23 1/4 in. (47.9 x 59.1 cm) Gift of J. Pierpont Morgan, 1906                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
307749 07.225.301 0 1 437947 European Paintings 15 Painting, sketch for a ceiling decoration 14088 Flora and Zephyr           Artist 2   Jacob de Wit Dutch, Amsterdam 1695–1754 Amsterdam   Wit, Jacob de 18256 Dutch 11 1695 1754 1743 1743 1743 Oil on canvas 953 20 7/8 x 24 7/8 in. (53 x 63.2 cm) Gift of J. Pierpont Morgan, 1906                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
307750 07.225.296 0 1 437948 European Paintings 15 Painting, sketch for a ceiling decoration 14088 Allegory of Government: Wisdom Defeating Discord           Artist 2   Jacob de Wit Dutch, Amsterdam 1695–1754 Amsterdam   Wit, Jacob de 18256 Dutch 11 1695 1754   1715 1754 Oil on canvas 953 20 1/8 x 15 3/8 in. (51.1 x 39.1 cm) Gift of J. Pierpont Morgan, 1906                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
307751 07.225.257 0 1 437949 European Paintings 15 Painting, grisaille 14120 Children Playing with a Goat           Artist 2 Style of Jacob de Wit Dutch, 18th century   Wit, Jacob de 18256 Dutch 11 1695 1754   1715 1754 Oil on canvas 953 26 3/4 x 41 in. (67.9 x 104.1 cm) Gift of J. Pierpont Morgan, 1906                       Paintings 11   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 126.436ms · Data license: CC0 · Data source: metmuseum/openaccess